head(RepairData)
## CreatedDate YearMonth UnitNumber VMRS JobType UnitType
## 1 2015-01-02 00:00:00.000 2015-01 08I005 13-61 L 08I
## 2 2015-01-02 00:00:00.000 2015-01 08I005 13-61 L 08I
## 3 2015-01-02 00:00:00.000 2015-01 08I005 07-61 L 08I
## 4 2015-01-02 00:00:00.000 2015-01 08I005 07-61 L 08I
## 5 2015-01-02 00:00:00.000 2015-01 08I005 70-61-000 L 08I
## 6 2015-01-02 00:00:00.000 2015-01 08I005 70-61-000 L 08I
## Vendor RepairNotes Ext_Cost Parts_Cost
## 1 NULL REPAIR/MODIF BOOM & COMPONENTS 0 0
## 2 NULL REPAIR/MODIF BOOM & COMPONENTS 0 0
## 3 NULL LUBRICATE BOOM & COMPONENTS 0 0
## 4 NULL LUBRICATE BOOM & COMPONENTS 0 0
## 5 NULL PERFORM BOOM & COMPONENTS PIKE BOOM INSPECTION 0 0
## 6 NULL PERFORM BOOM & COMPONENTS PIKE BOOM INSPECTION 0 0
## Labor_Hours DateMY
## 1 2.72 2015-01-01
## 2 0.00 2015-01-01
## 3 1.12 2015-01-01
## 4 0.00 2015-01-01
## 5 3.27 2015-01-01
## 6 0.00 2015-01-01
The data elements in this set are:
We’ll start by taking a look at the data trends over the past years in the 3 Job Type categories, and turning MonthYear into date data
## # A tibble: 6 x 5
## YearMonth ExtCost PartsCost LaborCost GraphName
## <chr> <dbl> <dbl> <dbl> <chr>
## 1 2015-01 1178927. 324719. 2155102. January 2015
## 2 2015-02 1520721. 420885. 2906847 February 2015
## 3 2015-03 2069592. 478191. 3730920 March 2015
## 4 2015-04 1455493. 375864. 2509432. April 2015
## 5 2015-05 2044913. 420283. 3061500 May 2015
## 6 2015-06 2414304. 553826. 3527547 June 2015
Seeing the increase in Extended Cost, lets dig into the top 20 vendors from 2018 to 2020 to see the delta over the past few years.
## # A tibble: 20 x 2
## Vendor ExtCost
## <chr> <dbl>
## 1 ALTEC INDUSTRIES INC. 31322943.
## 2 REPAIR CENTRAL LLC 22621281.
## 3 BRIDGESTONE AMERICAS TIRE OPERATIONS 8521351.
## 4 MISCELLANEOUS VENDOR 6772268.
## 5 FORD QUALITY FLEET CARE 2806376.
## 6 GMFLEETTRAC PROCESSING CENTER 2744641.
## 7 RUSH TRUCK CENTERS OF TEXAS 2469541.
## 8 SOUTHERN TIRE MART LLC 2396538.
## 9 FLEET CHARGE 1164497.
## 10 JAMES RIVER EQUIPMENT-CHARLOTTE 1115563.
## 11 GOODYEAR TIRE & RUBBER CO 803480.
## 12 NAPA 01709 783636.
## 13 TSE INTERNATIONAL INC 708575.
## 14 KENWOOD USA CORP COMM-LAND MOB 673399.
## 15 SAFELITE GLASS CORP 636720.
## 16 JIFFY LUBE 2738 WAKE FOREST NC 626094.
## 17 GLOBAL RENTAL CO INC 624192.
## 18 VERMEER SOUTHEAST SALES 585779.
## 19 TEREX GLOBAL GMBH 575038.
## 20 RECHTIEN INTERNATIONAL-FLEET 561723.
Now, we can take a look at the trends that each of the top 20 vendors went through over the past 3 years.
The chart highlights the growth of Altec and Repair Central in comparison to all other vendors. The second chart is a cleaner look with all other vendors lumped into All Others. But when we look at all vendors, we can see there is a general growth from all major external vendors over the past 3 years.